Synchronization of dissimilar databases

ABSTRACT

To synchronize databases between disparate data processing environments, a buffer, which is part of a first data processing environment having a first database, is loaded with a database update. Loading the buffer does not commit the database update to the first database in the first data processing environment. A remote function is called in the first data processing environment to apply the database update to a second database in a disparate second data processing environment. In response to the remote function determining that the second database has been successfully updated with the database update, the database update is committed to the first database. In response to the remote function determining that the second database has not been successfully updated with the database update, the database update is rolled back in the buffer such that the first data processing environment is unaware of an attempted update to the first database.

The present application claims priority under 35 U.S.C. §120 as acontinuation application to application Ser. No. 11/669,655, entitled“SYNCHRONIZATION OF DISSIMILAR DATABASES,” filed on Jan. 31, 2007, whichis hereby incorporated by reference in its entirety.

BACKGROUND OF THE INVENTION

1. Technical Field

The present disclosure relates in general to the field of computers, andmore particularly to the use of computer software. Still moreparticularly, the present disclosure relates to the synchronization ofdissimilar databases in different systems.

2. Description of the Related Art

From a high-level perspective, a computer can be viewed as a collectionof hardware resources that, under the direction of an operating system,executes software code to manipulate data. An exemplary form of suchdata is a table.

Oftentimes, two disparate computer systems need to coordinate updatingcopies of a same table in a synchronous manner. That is, a firstcomputer system, which utilizes a first type of software, may update atable. In response to the first computer system updating the table, asecond computer system, which utilizes a second type of software, needsto update the same table, which is stored the second computer in adifferent format, which uses a different protocol from that found in thefirst system.

An example of such a need to synchronize table updating is that foundwith an SAP™ system and a non-SAP™ external system. SAP™ is a well knownEnterprise Resource Planning (ERP) software that integrates data from anenterprise's departments such as accounting, payroll, human resources,inventory control, sales, legal, etc. SAP™ has very specific protocols,one of which is problematic. Specifically, when a SAP™ system updates alocal SAP™ database table, this update can be sent to a non-SAP™ tablein an external (non-SAP™) system. However, if the external system failsto update the non-SAP™ table, the SAP™ system has no way of knowing thisunder SAP™ protocol. Thus, if the non-SAP™ system fails to make theproper update to the non-SAP™ table, then data in the SAP™ and non-SAP™systems are no longer synchronized.

SUMMARY OF THE INVENTION

To synchronize databases between disparate data processing environments,a buffer, which is part of a first data processing environment having afirst database, is loaded with a database update. Loading the bufferdoes not commit the database update to the first database in the firstdata processing environment. A remote function is called in the firstdata processing environment to apply the database update to a seconddatabase that is part of a disparate second data processing environment.In response to the remote function determining that the second databasehas been successfully updated with the database update, the databaseupdate is committed to the first database in the first data processingenvironment. In response to the remote function determining that thesecond database has not been successfully updated with the databaseupdate, the database update is rolled back in the buffer such that thefirst data processing environment is unaware of an attempted update tothe first database.

The above, as well as additional purposes, features, and advantages ofthe present invention will become apparent in the following detailedwritten description.

BRIEF DESCRIPTION OF THE DRAWINGS

The novel features believed characteristic of the invention are setforth in the appended claims. The invention itself, however, as well asa preferred mode of use, further purposes and advantages thereof, willbest be understood by reference to the following detailed description ofan illustrative embodiment when read in conjunction with theaccompanying drawings, where:

FIG. 1 depicts an interaction between an SAP™ system and a non-SAP™system during a joint database update;

FIG. 2 is a flow-chart of exemplary steps taken to synchronize databasesfound in the SAP™ system and the non-SAP™ system shown in FIG. 1;

FIG. 3 illustrates an exemplary computer in which the present inventionmay be utilized;

FIGS. 4A-B are flow-charts showing steps taken to deploy softwarecapable of executing the steps described in FIGS. 1-2; and

FIGS. 5A-B are flow-charts showing steps taken to execute the stepsshown in FIGS. 1-2 using an on-demand service provider.

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENT

With reference now to the figures, and in particular to FIG. 1, there isdepicted a software diagram of two disparate computer software systems:a SAP™ software system 102 and a non-SAP™ software system 104. In oneembodiment, the SAP™ software system 102 and the non-SAP™ softwaresystem 104 operate within different hardware systems, while in anotherembodiment, the SAP™ software system 102 and the non-SAP™ softwaresystem 104 are simply different software partitions within a singlehardware system.

Because the two software systems (SAP™ software system 102 and non-SAP™software system 104) are disparate (e.g., they have different protocols,definitions, organization, etc.), SAP™ software system 102 is initiallyunable to know if a synchronization of database updates between SAP™software system 102 and non-SAP™ software system 104 was successful.That is, assume that a database update is made to SAP™ database tables114. In order for SAP™ software system 102 and non-SAP™ software system104 to be synchronized, the non-SAP™ database tables 110 must alsoreceive the same database update. However, since the SAP™ softwaresystem 102 and non-SAP™ software system 104 are disparate, the SAP™software system 102 is unable to know if the update to the non-SAP™database tables 110 in non-SAP™ software system 104 was successful.

To address this problem in accordance with the present novel disclosure,updates to SAP™ database tables 114 are initially pushed onto a SAP™database table update queue 106 in SAP™ software system 102, whichincludes a “Remote Function Call” 108 at the end (after all updates) ofthe queue. Each update in the SAP™ database table update queue 106 isinitially updated in a buffer 118, which holds a copy of updated datafrom a table, found in SAP™ database tables 114 that are to be updated.As soon as all updates are successfully made in the buffer 118, the“Remote Function Call” 108 passes the updates to the non-SAP™ databasetables 110 via middleware 116. Since the “Remote Function Call” 108 isfound at the end of the queue in the SAP™ database table update queue106, the non-SAP™ software system 104 is never called unless all updatesfound in the SAP™ database table update queue 106 are successfullyimplemented and sent to buffer 118. If these updates are not allsuccessful, then the SAP™ database tables 114 are never updated, and thenon-SAP™ software system 104 is never called.

A non-SAP™ database table update confirmation program 112 monitorswhether the updates to the non-SAP™ database tables 110 are successfulor not. A message, which is sent from the non-SAP™ database table updateconfirmation program 112 to the “Remote Function Call” 108, tells the“Remote Function Call” 108 if the update to the non-SAP™ database tables110 was successful. If it was, then the SAP™ database table update queue106 releases the updates to the SAP™ database tables 114, eitherdirectly or, as shown in a preferred embodiment in FIG.1, by directlycopying updated tables from the buffer 118 over to the SAP™ databasetables 114. However, if the update to the non-SAP™ database tables 110was not successful, then the update changes located in the SAP™ databasetable update queue 106 are deleted, thus “rolling back” the updates inthe SAP™ software system 102.

Note that in a preferred embodiment, middleware 116 interfaces SAP™software system 102 with non-SAP™ software system 104. Middleware 116passes SAP™ calls between SAP™ software system 102 and non-SAP™ softwaresystem 104 such that if non-SAP™ software system 104 does not receive amessage to update the non-SAP™ database tables 110, or if non-SAP™software system 104 is unable to update the non-SAP™ database tables110, a BAD response is sent to the SAP™ software system 102. Similarly,if the non-SAP™ software system 104 is able to update the non-SAP™database tables 110, then a GOOD response is sent to the SAP™ softwaresystem 102 indicating the successful updating of the non-SAP™ databasetables 110.

Referring now to FIG. 2, a flow-chart of exemplary steps taken tosynchronize databases in disparate computer systems is presented. Afterinitiator block 202, which may be prompted by a command to update adatabase in a first (hardware or software) system, the update isinitiated in, but not committed to, the first system (block 204). If theupdate was successful in the first system (query block 206), then a“Remote Function Call” is made to the second (hardware or software)system, instructing the second system to update a corresponding butdissimilar (due to different protocol, format, etc.) database in thesecond system with the update (block 208). If the update to the databasein the second system is successful (query block 210), then the update iscommitted in the first system (block 212) and the process ends(terminator block 216). However, if the update in the second systemfails (query block 210), then the update in the first system is rolledback (block 214), such that the first system never sees the update inits database.

Returning to query block 206, if the update in the first system isunsuccessful, then the second system is never involved, and the updateto the database in the first system never takes place (block 214), thusending the process (terminator block 216).

Note that while the updated databases are referenced as database tablesfor exemplary purposes, any type of database or data file may be updatedin a synchronous manner by utilizing the method described herein.

While FIG. 1 and FIG. 2 provide a high-level overview of the presentdisclosure, presented now are additional details of the inventiveprocess in exemplary and narrative form for a SAP™ system.

Sales Order Create Scenario

When a sales order is created in SAP™, the sales order needs to becreated simultaneously in the external (disparate) system. If thedatabase updates in SAP™ fail, the order should not be created in theexternal system. Similarly if the external system fails to create theorder then that order should not be created in SAP™.

Sales Order Change Scenario

When a sales order is changed in SAP™, it needs to be changedsimultaneously in the external system. If the database updates in SAP™fail, the order should not be changed in the external system. Similarlyif the external system fails to make changes in the order then thechanges made in the SAP™ order need to be rolled back.

Although the above description relates to orders, the method describedherein relates to any object or information which is needed to besynchronized across dissimilar systems.

As described herein, a “Remote Function Call” is made, to the externaldissimilar database, after all the database table updates in SAP™ arecarried out but not committed. The external system responds back to SAP™system with a return code stating if the updates are successful or not.SAP™ database updates are committed upon successful database updates inthe external database. SAP™ database updates are rolled back if thedatabase updates in the external database fail.

Following is an exemplary SAP™-based implementation of the presentlydisclosed method.

First, SAP™ makes all the database updates in “Update Task”. Wheneverprocessing needs to make database updates, SAP™ puts Structured QueryLanguage (SQL) statements to update a database table into a “FunctionModule” that is executed in the “Update Task.” As and when the “UpdateTask” function module, which has SQL statements to update databasetables, is called, the database updates are not carried out immediately.Rather, a “Function Module” call is put in a Dynamic Update task queue.Once the normal processing is over, all of the Function modules calledin “Update Task” are processed in the order of update task queuing(i.e., the first updates that are placed in the queue are processedfirst). If any update fails, processing of the update task of all theupdates are rolled back. Alternatively, set of commands can be placed ina “Form”, after the execution of “Commit Work.” This can be done byperforming the form “On Commit.” Thus, execution of “Commit Work” endsnormal processing. After the command “Commit Work” is executed, all theforms that are performed “On Commit” are executed. Thereafter, SAP™initiates processing of function modules in “Update Task” in the orderof dynamic update the task queue. All “Function Modules” in the updatetask are processed in a single logical unit of work. If any part of the“Function Module” fails, none of the database updates are committed tothe database.

The order to update the database in the external system is created inthe external system by making a real time “Remote Function Call” to theexternal system during the same session/Logical unit of work where orderis being created/changed in SAP™. It is necessary to make sure that allthe Database updates are successfully carried out in SAP™ before tryingto make the “Remote Function Call” to create the order in the externalsystem.

The “Remote Function Call” to the external system is placed in afunction module that is called in update task. To ensure that the“Remote Function Call” to the external system is placed at the end ofdynamic update task queue, the function module that has the “RemoteFunction Call,” is placed in a form that is performed “On Commit Level3”. Since all of the forms that are called “on commit” are processedafter the normal processing as explained earlier, and within the formsthat are performed on commit, the level 3 forms are performed in theend. This ensures that the Function module that has a “Remote FunctionCall” to the external system is placed at the end of dynamic update taskqueue. If any of the SAP™ database updates fail, then this call to theexternal system will never be made, thus ensuring that if an order isnot successfully created/changed in SAP™, it will not be created/changedin the external system. If the “Remote Function Call” is made and issuccessful, then the SAP™ order is saved without any update failure. Asthe order is created/updated successfully in the external system, bothsystems are in “Sync”. If the order can not be created/changed in theexternal system due to any problems such as database update failure,then the “Remote Function Call” returns an indicator to SAP™ saying thatthe order was not successfully created/updated the external system. Insuch cases, since the “Remote Function Call” is placed in a functionmodule that is executed in an update task, after checking the “bad”indicator indicating that the order in not successfully created/updatedthe external system, all of the database updates in SAP™ are rolled backby giving an express message “Message Type X”. This makes sure that bothSAP™ and external system are always in sync.

Thus, the above-described method causes any external database to alwaysbe kept in “Sync” with the SAP™ database in real time environment.

With reference now to FIG. 3, there is depicted a block diagram of anexemplary client computer 302, in which the present invention may beutilized. Note that some or all of the exemplary architecture shown forclient computer 302 may be utilized by encryption logic 208, decryptionlogic 214, data center VPN server 218, database server 226 and corporatedatabase 228 shown in FIG. 2, as well as software deploying server 350shown in FIG. 3.

Client computer 302 includes a processor unit 304 that is coupled to asystem bus 306. A video adapter 308, which drives/supports a display310, is also coupled to system bus 306. System bus 306 is coupled via abus bridge 312 to an Input/Output (I/O) bus 314. An I/O interface 316 iscoupled to I/O bus 314. I/O interface 316 affords communication withvarious I/O devices, including a keyboard 318, a mouse 320, a CompactDisk-Read Only Memory (CD-ROM) drive 322, a floppy disk drive 324, and aflash drive memory 326. The format of the ports connected to I/Ointerface 316 may be any known to those skilled in the art of computerarchitecture, including but not limited to Universal Serial Bus (USB)ports.

Client computer 302 is able to communicate with a software deployingserver 350 via a network 328 using a network interface 330, which iscoupled to system bus 306. Network 328 may be an external network suchas the Internet, or an internal network such as an Ethernet or a VirtualPrivate Network (VPN). Note the software deploying server 350 mayutilize a same or substantially similar architecture as client computer302.

A hard drive interface 332 is also coupled to system bus 306. Hard driveinterface 332 interfaces with a hard drive 334. In a preferredembodiment, hard drive 334 populates a system memory 336, which is alsocoupled to system bus 306. System memory is defined as a lowest level ofvolatile memory in client computer 302. This volatile memory includesadditional higher levels of volatile memory (not shown), including, butnot limited to, cache memory, registers and buffers. Data that populatessystem memory 336 includes client computer 302's operating system (OS)338 and application programs 344.

OS 338 includes a shell 340, for providing transparent user access toresources such as application programs 344. Generally, shell 340 is aprogram that provides an interpreter and an interface between the userand the operating system. More specifically, shell 340 executes commandsthat are entered into a command line user interface or from a file.Thus, shell 340 (as it is called in UNIX®), also called a commandprocessor in Windows®, is generally the highest level of the operatingsystem software hierarchy and serves as a command interpreter. The shellprovides a system prompt, interprets commands entered by keyboard,mouse, or other user input media, and sends the interpreted command(s)to the appropriate lower levels of the operating system (e.g., a kernel342) for processing. Note that while shell 340 is a text-based,line-oriented user interface, the present invention will equally wellsupport other user interface modes, such as graphical, voice, gestural,etc.

As depicted, OS 338 also includes kernel 342, which includes lowerlevels of functionality for OS 338, including providing essentialservices required by other parts of OS 338 and application programs 344,including memory management, process and task management, diskmanagement, and mouse and keyboard management.

Application programs 344 include a browser 346. Browser 346 includesprogram modules and instructions enabling a World Wide Web (WWW) client(i.e., client computer 302) to send and receive network messages to theInternet using HyperText Transfer Protocol (HTTP) messaging, thusenabling communication with software deploying server 350.

Application programs 344 in client computer 302's system memory (as wellas software deploying server 350's system memory) also include aDatabase Synchronization Program (DSP) 348. DSP 348 includes code forimplementing the processes described in FIGS. 1-2. In one embodiment,client computer 302 is able to download DSP 348 from software deployingserver 350.

The hardware elements depicted in client computer 302 are not intendedto be exhaustive, but rather are representative to highlight essentialcomponents required by the present invention. For instance, clientcomputer 302 may include alternate memory storage devices such asmagnetic cassettes, Digital Versatile Disks (DVDs), Bernoullicartridges, and the like. These and other variations are intended to bewithin the spirit and scope of the present invention.

Note further that, in a preferred embodiment of the present invention,software deploying server 350 performs all of the functions associatedwith the present invention (including execution of DSP 348), thusfreeing client computer 302 from having to use its own internalcomputing resources to execute DSP 348.

It should be understood that at least some aspects of the presentinvention may alternatively be implemented in a computer-readable mediumthat contains a program product. Programs defining functions of thepresent invention can be delivered to a data storage system or acomputer system via a variety of tangible signal-bearing media, whichinclude, without limitation, non-writable storage media (e.g., CD-ROM),writable storage media (e.g., hard disk drive, read/write CD ROM,optical media), as well as non-tangible communication media, such ascomputer and telephone networks including Ethernet, the Internet,wireless networks, and like network systems. It should be understood,therefore, that such signal-bearing media when carrying or encodingcomputer readable instructions that direct method functions in thepresent invention, represent alternative embodiments of the presentinvention. Further, it is understood that the present invention may beimplemented by a system having means in the form of hardware, software,or a combination of software and hardware as described herein or theirequivalent.

Software Deployment

As described above, in one embodiment, the processes described by thepresent invention, including the functions of DSP 348, are performed byservice provider server 350. Alternatively, DSP 348 and the methoddescribed herein, and in particular as shown and described in FIGS. 1-2,can be deployed as a process software from service provider server 350to client computer 302. Still more particularly, process software forthe method so described may be deployed to service provider server 350by another service provider server (not shown).

Referring then to FIGS. 4A-B, step 400 begins the deployment of theprocess software. The first thing is to determine if there are anyprograms that will reside on a server or servers when the processsoftware is executed (query block 402). If this is the case, then theservers that will contain the executables are identified (block 404).The process software for the server or servers is transferred directlyto the servers' storage via File Transfer Protocol (FTP) or some otherprotocol or by copying though the use of a shared file system (block406). The process software is then installed on the servers (block 408).

Next, a determination is made on whether the process software is to bedeployed by having users access the process software on a server orservers (query block 410). If the users are to access the processsoftware on servers, then the server addresses that will store theprocess software are identified (block 412).

A determination is made if a proxy server is to be built (query block414) to store the process software. A proxy server is a server that sitsbetween a client application, such as a Web browser, and a real server.It intercepts all requests to the real server to see if it can fulfillthe requests itself. If not, it forwards the request to the real server.The two primary benefits of a proxy server are to improve performanceand to filter requests. If a proxy server is required, then the proxyserver is installed (block 416). The process software is sent to theservers either via a protocol such as FTP or it is copied directly fromthe source files to the server files via file sharing (block 418).Another embodiment would be to send a transaction to the servers thatcontained the process software and have the server process thetransaction, then receive and copy the process software to the server'sfile system. Once the process software is stored at the servers, theusers, via their client computers, then access the process software onthe servers and copy to their client computers file systems (block 420).Another embodiment is to have the servers automatically copy the processsoftware to each client and then run the installation program for theprocess software at each client computer. The user executes the programthat installs the process software on his client computer (block 422)then exits the process (terminator block 424).

In query step 426, a determination is made whether the process softwareis to be deployed by sending the process software to users via e-mail.The set of users where the process software will be deployed areidentified together with the addresses of the user client computers(block 428). The process software is sent via e-mail to each of theusers' client computers (block 430). The users then receive the e-mail(block 432) and then detach the process software from the e-mail to adirectory on their client computers (block 434). The user executes theprogram that installs the process software on his client computer (block422) then exits the process (terminator block 424).

Lastly a determination is made as to whether the process software willbe sent directly to user directories on their client computers (queryblock 436). If so, the user directories are identified (block 438). Theprocess software is transferred directly to the user's client computerdirectory (block 440). This can be done in several ways such as but notlimited to sharing of the file system directories and then copying fromthe sender's file system to the recipient user's file system oralternatively using a transfer protocol such as File Transfer Protocol(FTP). The users access the directories on their client file systems inpreparation for installing the process software (block 442). The userexecutes the program that installs the process software on his clientcomputer (block 422) and then exits the process (terminator block 424).

VPN Deployment

The present software can be deployed to third parties as part of aservice wherein a third party VPN service is offered as a securedeployment vehicle or wherein a VPN is build on-demand as required for aspecific deployment.

A virtual private network (VPN) is any combination of technologies thatcan be used to secure a connection through an otherwise unsecured oruntrusted network. VPNs improve security and reduce operational costs.The VPN makes use of a public network, usually the Internet, to connectremote sites or users together. Instead of using a dedicated, real-worldconnection such as leased line, the VPN uses “virtual” connectionsrouted through the Internet from the company's private network to theremote site or employee. Access to the software via a VPN can beprovided as a service by specifically constructing the VPN for purposesof delivery or execution of the process software (i.e. the softwareresides elsewhere) wherein the lifetime of the VPN is limited to a givenperiod of time or a given number of deployments based on an amount paid.

The process software may be deployed, accessed and executed througheither a remote-access or a site-to-site VPN. When using theremote-access VPNs the process software is deployed, accessed andexecuted via the secure, encrypted connections between a company'sprivate network and remote users through a third-party service provider.The enterprise service provider (ESP) sets a network access server (NAS)and provides the remote users with desktop client software for theircomputers. The telecommuters can then dial a toll-free number or attachdirectly via a cable or DSL modem to reach the NAS and use their VPNclient software to access the corporate network and to access, downloadand execute the process software.

When using the site-to-site VPN, the process software is deployed,accessed and executed through the use of dedicated equipment andlarge-scale encryption that are used to connect a company's multiplefixed sites over a public network such as the Internet.

The process software is transported over the VPN via tunneling which isthe process of placing an entire packet within another packet andsending it over a network. The protocol of the outer packet isunderstood by the network and both points, called tunnel interfaces,where the packet enters and exits the network.

Software Integration

The process software which consists of code for implementing the processdescribed herein may be integrated into a client, server and networkenvironment by providing for the process software to coexist withapplications, operating systems and network operating systems softwareand then installing the process software on the clients and servers inthe environment where the process software will function.

The first step is to identify any software on the clients and servers,including the network operating system where the process software willbe deployed, that are required by the process software or that work inconjunction with the process software. This includes the networkoperating system that is software that enhances a basic operating systemby adding networking features.

Next, the software applications and version numbers will be identifiedand compared to the list of software applications and version numbersthat have been tested to work with the process software. Those softwareapplications that are missing or that do not match the correct versionwill be upgraded with the correct version numbers. Program instructionsthat pass parameters from the process software to the softwareapplications will be checked to ensure the parameter lists match theparameter lists required by the process software. Conversely parameterspassed by the software applications to the process software will bechecked to ensure the parameters match the parameters required by theprocess software. The client and server operating systems including thenetwork operating systems will be identified and compared to the list ofoperating systems, version numbers and network software that have beentested to work with the process software. Those operating systems,version numbers and network software that do not match the list oftested operating systems and version numbers will be upgraded on theclients and servers to the required level.

After ensuring that the software, where the process software is to bedeployed, is at the correct version level that has been tested to workwith the process software, the integration is completed by installingthe process software on the clients and servers.

On Demand

The process software is shared, simultaneously serving multiplecustomers in a flexible, automated fashion. It is standardized,requiring little customization and it is scalable, providing capacity ondemand in a pay-as-you-go model.

The process software can be stored on a shared file system accessiblefrom one or more servers. The process software is executed viatransactions that contain data and server processing requests that useCPU units on the accessed server. CPU units are units of time such asminutes, seconds, hours on the central processor of the server.Additionally the accessed server may make requests of other servers thatrequire CPU units. CPU units describe an example that represents but onemeasurement of use. Other measurements of use include but are notlimited to network bandwidth, memory utilization, storage utilization,packet transfers, complete transactions etc.

When multiple customers use the same process software application, theirtransactions are differentiated by the parameters included in thetransactions that identify the unique customer and the type of servicefor that customer. All of the CPU units and other measurements of usethat are used for the services for each customer are recorded. When thenumber of transactions to any one server reaches a number that begins toaffect the performance of that server, other servers are accessed toincrease the capacity and to share the workload. Likewise when othermeasurements of use such as network bandwidth, memory utilization,storage utilization, etc. approach a capacity so as to affectperformance, additional network bandwidth, memory utilization, storageetc. are added to share the workload.

The measurements of use used for each service and customer are sent to acollecting server that sums the measurements of use for each customerfor each service that was processed anywhere in the network of serversthat provide the shared execution of the process software. The summedmeasurements of use units are periodically multiplied by unit costs andthe resulting total process software application service costs arealternatively sent to the customer and/or indicated on a web siteaccessed by the customer which then remits payment to the serviceprovider.

In another embodiment, the service provider requests payment directlyfrom a customer account at a banking or financial institution.

In another embodiment, if the service provider is also a customer of thecustomer that uses the process software application, the payment owed tothe service provider is reconciled to the payment owed by the serviceprovider to minimize the transfer of payments.

With reference now to FIGS. 5A-B, initiator block 502 begins the OnDemand process. A transaction is created than contains the uniquecustomer identification, the requested service type and any serviceparameters that further, specify the type of service (block 504). Thetransaction is then sent to the main server (block 506). In an On Demandenvironment the main server can initially be the only server, then ascapacity is consumed other servers are added to the On Demandenvironment.

The server central processing unit (CPU) capacities in the On Demandenvironment are queried (block 508). The CPU requirement of thetransaction is estimated, then the servers available CPU capacity in theOn Demand environment are compared to the transaction CPU requirement tosee if there is sufficient CPU available capacity in any server toprocess the transaction (query block 510). If there is not sufficientserver CPU available capacity, then additional server CPU capacity isallocated to process the transaction (block 512). If there was alreadysufficient available CPU capacity then the transaction is sent to aselected server (block 514).

Before executing the transaction, a check is made of the remaining OnDemand environment to determine if the environment has sufficientavailable capacity for processing the transaction. This environmentcapacity consists of such things as but not limited to networkbandwidth, processor memory, storage etc. (block 516). If there is notsufficient available capacity, then capacity will be added to the OnDemand environment (block 518). Next the required software to processthe transaction is accessed, loaded into memory, then the transaction isexecuted (block 520).

The usage measurements are recorded (block 522). The utilizationmeasurements consist of the portions of those functions in the On Demandenvironment that are used to process the transaction. The usage of suchfunctions as, but not limited to, network bandwidth, processor memory,storage and CPU cycles are what is recorded. The usage measurements aresummed, multiplied by unit costs and then recorded as a charge to therequesting customer (block 524).

If the customer has requested that the On Demand costs be posted to aweb site (query block 526), then they are posted (block 528). If thecustomer has requested that the On Demand costs be sent via e-mail to acustomer address (query block 530), then these costs are sent to thecustomer (block 532). If the customer has requested that the On Demandcosts be paid directly from a customer account (query block 534), thenpayment is received directly from the customer account (block 536). TheOn Demand process is then exited at terminator block 538.

As described herein, the present invention provides a method, system,and computer-readable medium for synchronizing databases between twodisparate computer systems. In one embodiment, the method includes thesteps of: loading a buffer, which is part of a first computer system,with a database update, wherein loading the buffer does not initiallycommit the database update to a first database in the first computersystem; calling a remote function, in the first computer system, toincorporate the database update into a second database that is part of asecond computer system, wherein the first and second computer systemsoperate in disparate environments; in response to the remote functiondetermining that the second database has been successfully updated withthe database update, committing the database update to the firstdatabase in the first computer system; and in response to the remotefunction determining that the second database has not been successfullyupdated with the database update, rolling back the database update inthe buffer such that the first database in the first computer system isunaware of an attempted updating of the first database. In oneembodiment, the remote function is positioned after a plurality ofdatabase updates in a database table update queue in the first computersystem, and wherein the remote function is not called until all of thedatabase updates are successfully implemented in the buffer. Thus,committing the database update allows the first computer system toutilize the database update. The disparate environments of the first andsecond computer systems may be caused by different hardwarearchitectures in the first and second computer systems. Alternatively,the disparate environments of the first and second computer systems arecaused by the first computer system operating under a first softwaresystem and the second computer system operating under a second softwaresystem. If the disparate environments are software-based, the firstsoftware system may be initially designed by a software manufacturersuch that the first software system is unable to confirm that the secondsoftware system has updated the second database. In one embodiment, thefirst software system is a SAP™ software system, and the second softwaresystem is a non-SAP™ software system.

While the present invention has been particularly shown and describedwith reference to a preferred embodiment, it will be understood by thoseskilled in the art that various changes in form and detail may be madetherein without departing from the spirit and scope of the invention.For example, while the method described herein is related tosynchronizing tables, any type of data structure may be synchronized inaccordance with the present disclosure. Furthermore, as used in thespecification and the appended claims, the term “computer” or “system”or “computer system” or “computing device” includes any data processingsystem including, but not limited to, personal computers, servers,workstations, network computers, main frame computers, routers,switches, Personal Digital Assistants (PDA's), telephones, and any othersystem capable of processing, transmitting, receiving, capturing and/orstoring data.

1. A method for synchronizing databases between disparate dataprocessing environments, the method comprising: loading a buffer, whichis part of a first data processing environment having a first database,with a database update, wherein loading the buffer does not commit thedatabase update to the first database in the first data processingenvironment; calling a remote function, in the first data processingenvironment, to apply the database update to a second database that ispart of a disparate second data processing environment; in response tothe remote function determining that the second database has beensuccessfully updated with the database update, committing the databaseupdate to the first database in the first data processing environment;and in response to the remote function determining that the seconddatabase has not been successfully updated with the database update,rolling back the database update in the buffer such that the first dataprocessing environment is unaware of an attempted update to the firstdatabase.
 2. The method of claim 1, wherein the first data processingenvironment includes a database table update queue containing aplurality of database updates including the database update, and whereincalling the remote function includes calling the remote function onlyafter all of the plurality of database updates in the data table updatequeue are successfully loaded in the buffer.
 3. The method of claim 1,wherein the disparate first and second data processing environmentsrespectively comprise first and second computer systems having differenthardware architectures.
 4. The method of claim 1, wherein the disparatefirst and second data processing environments respectively comprisedisparate first and second software systems running on at least onehardware computer system.
 5. The method of claim 4, wherein the firstsoftware system, as designed, is unable to confirm that the secondsoftware system has updated the second database.
 6. The method of claim4, and further comprising: the remote function applying the databaseupdate to the second database via middleware providing an interfacebetween the first and second software systems.
 7. A system comprising: aprocessor; and data storage coupled to the processor, the data storageincluding program code executable by the processor and configured tosynchronize databases between disparate data processing environments by:loading a buffer, which is part of the first data processing environmenthaving a first database, with a database update, wherein loading thebuffer does not commit the database update to the first database in thefirst data processing environment; calling a remote function, in thefirst data processing environment, to apply the database update to asecond database that is part of a disparate second data processingenvironment; in response to the remote function determining that thesecond database has been successfully updated with the database update,committing the database update to the first database in the first dataprocessing environment; and in response to the remote functiondetermining that the second database has not been successfully updatedwith the database update, rolling back the database update in the buffersuch that the first data processing environment is unaware of anattempted update to the first database.
 8. The system of claim 7,wherein the first data processing environment includes a database tableupdate queue containing a plurality of database updates including thedatabase update, and wherein calling the remote function includescalling the remote function only after all of the plurality of databaseupdates in the data table update queue are successfully loaded in thebuffer.
 9. The system of claim 7, wherein the disparate first and seconddata processing environments respectively comprise first and secondcomputer systems having different hardware architectures.
 10. The systemof claim 7, wherein the disparate first and second data processingenvironments respectively comprise disparate first and second softwaresystems running on at least one hardware computer system.
 11. The systemof claim 10, wherein the first software system, as designed, is unableto confirm that the second software system has updated the seconddatabase.
 12. The system of claim 10, wherein the program code isfurther configured to synchronize databases between disparate dataprocessing environments by causing the remote function to apply thedatabase update to the second database via middleware providing aninterface between the first and second software systems.
 13. A programproduct, comprising: a non-transitory computer-readable storage medium;and program code stored on the non-transitory computer-readable storagemedium and configured to synchronize databases between disparate dataprocessing environments by: loading a buffer, which is part of the firstdata processing environment having a first database, with a databaseupdate, wherein loading the buffer does not commit the database updateto the first database in the first data processing environment; callinga remote function, in the first data processing environment, to applythe database update to a second database that is part of a disparatesecond data processing environment; in response to the remote functiondetermining that the second database has been successfully updated withthe database update, committing the database update to the firstdatabase in the first data processing environment; and in response tothe remote function determining that the second database has not beensuccessfully updated with the database update, rolling back the databaseupdate in the buffer such that the first data processing environment isunaware of an attempted update to the first database.
 14. The programproduct of claim 13, wherein the first data processing environmentincludes a database table update queue containing a plurality ofdatabase updates including the database update, and wherein calling theremote function includes calling the remote function only after all ofthe plurality of database updates in the data table update queue aresuccessfully loaded in the buffer.
 15. The program product of claim 13,wherein the disparate first and second data processing environmentsrespectively comprise first and second computer systems having differenthardware architectures.
 16. The program product of claim 13, wherein thedisparate first and second data processing environments respectivelycomprise disparate first and second software systems running on at leastone hardware computer system.
 17. The program product of claim 16,wherein the first software system, as designed, is unable to confirmthat the second software system has updated the second database.
 18. Theprogram product of claim 16, wherein the program code is furtherconfigured to synchronize databases between disparate data processingenvironments by causing the remote function to apply the database updateto the second database via middleware providing an interface between thefirst and second software systems.
 19. The program product of claim 13,wherein the non-transitory computer-readable storage medium is acomponent of a remote server, and wherein the program code is deployableto a client computer from the remote server.
 20. The program product ofclaim 13, wherein the program code is provided by a service provider toa customer on an on-demand basis.